WIP/AR Aging
The WIP/AR Aging report shows accumulated WIP and AR in up to seven user-defined aging intervals. This report can be used to determine how much unbilled WIP and AR have accumulated for each client.
Two versions of the report are available.
- The standard version allows for extensive customization, filtering, and grouping, but can take a while to generate. You can also add a cover page to this version of the report.
- The optimized version generates quickly, but offers fewer customization options. Basic report options are preset based on common use of the report and cannot be changed. There are also fewer grouping and filtering options than in the standard report. You can identify this version by the word Optimized in the Type column.
The sections below describe the options available in this report.
Permissions Required for this Report
In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:
- Security group profile > Functional rights > Reports > Shared Library > Shared Views
- Security group profile > Functional rights > Reports > Firm Library > Custom
- Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
- Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
- Security group profile > Functional rights > Reports > Firm Library > <report name>
- Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients
Comparable Reports in CCH ProSystem fx Practice Management that are Comparable
In Practice Management, the comparable report is WIP/AR Aging.
Report Specifications
The following report options and filters are available to determine the report contents.
Options and Settings | ||
---|---|---|
Option | Setting | Description |
Note: This section does not display in the optimized report. Instead, certain options are applied by default, as indicated in the descriptions below. | ||
Include Clients with Transactions and AR Balance of $0.00 |
Yes/ No |
Includes or excludes clients with transactions in the date range of the report and those transactions equal $0.00. For the optimized report, this option is set to No. |
Calculate Aging for Undistributed Payments Using… |
List |
Determines the date to use for aging undistributed transactions. The options are Undistributed transaction date or Oldest unpaid invoice date. For the optimized report, this option is set to Undistributed transaction date. |
Show Client AR Limit |
Yes/No |
Includes or excludes the client AR limit. For the optimized report, this option is set to No. |
Show Client Last Payment Date and Amount |
Yes/No |
Includes or excludes the last received payment date and amount. For the optimized report, this option is set to Yes. |
Include Clients with Minimum AR Balance Of… |
Numerical |
Shows the clients with the specified minimum AR balance on the report. For the optimized report, this option is not applicable. |
Start Aging Period for Minimum AR Balance At… |
Numerical |
Determines the aging period to use as the first aging period for the AR balance on the report. For the optimized report, this option is set to 1. |
Include Clients with a Minimum WIP Balance Of… |
Numerical |
Shows the clients with the specified minimum WIP balance on the report. For the optimized report, this option is not applicable. |
Start Aging Period for Minimum WIP Balance At… |
Numerical |
Determines the aging period to use as the first aging period for the WIP balance on the report. For the optimized report, this option is set to 1. |
Set Number of Days for Aging Period 1 |
Numerical |
Determines the length of each aging period. Enter ‘0’ for periods you wish to hide on the report. For the optimized report, this option is set to 30. |
Set Number of Days for Aging Period 2 |
Numerical |
Determines the length of each aging period. Enter ‘0’ for periods you wish to hide on the report. For the optimized report, this option is set to 30. |
Set Number of Days for Aging Period 3 |
Numerical |
Determines the length of each aging period. Enter ‘0’ for periods you wish to hide on the report. For the optimized report, this option is set to 30. |
Set Number of Days for Aging Period 4 |
Numerical |
Determines the length of each aging period. Enter ‘0’ for periods you wish to hide on the report. For the optimized report, this option is set to 30. |
Set Number of Days for Aging Period 5 |
Numerical |
Determines the length of each aging period. Enter ‘0’ for periods you wish to hide on the report. For the optimized report, this option is set to 0. |
Set Number of Days for Aging Period 6 |
Numerical |
Determines the length of each aging period. Enter ‘0’ for periods you wish to hide on the report. For the optimized report, this option is set to 0. |
Set Number of Days for Aging Period 7 |
Numerical |
Determines the length of each aging period. Enter ‘0’ for periods you wish to hide on the report. For the optimized report, this option is set to 0. |
Select to Age Transaction Using… |
List |
Determines whether to age the transactions based on the Transaction date or the Accounting period date. For the optimized report, this option is set to Transaction date. |
Cutoff WIP Date (exclude transactions past this date) |
Date |
Determines the cutoff date for WIP. This excludes transactions that are after the date entered. For the optimized report, this option is set to Today. |
Cutoff AR Date (exclude transactions past this date) |
Date |
Determines the cutoff date for AR. This excludes transactions that are after the date entered. For the optimized report, this option is set to Today. |
Hide AR |
Yes/No |
Includes or excludes detailed AR transactions. For the optimized report, this option is set to No. |
Include Deleted Clients |
Yes/No |
Includes or excludes deleted client information. For the optimized report, this option is set to No. |
Default filters |
---|
There are no default filters for this report. |
Optional Filters | ||
---|---|---|
Available Fields | ||
Note: The options that are available in the optimized report are indicated with an asterisk (*) below. | ||
AR Limit |
Client ID.Sub ID* |
Financial Reporting Client Group |
Business Code |
Client Name* |
Line of Business |
Client |
Client Office* |
Manager |
Client – Principal |
Client Primary Service Type |
Primary Partner |
Client Bill Manager* |
Client Region |
Return Group |
Client Business Unit |
Client Sub ID | Sort Name |
Client ID* |
Client Type |
Grouping | ||
---|---|---|
Available Fields | ||
Note: The options that are available in optimized reports are indicated with an asterisk (*) in the tables below. | ||
Business Code |
Client Name |
Line of Business |
Client* |
Client Office* |
Manager |
Client – Principal |
Client Primary Service Type |
Primary Partner |
Client Bill Manager* |
Client Region |
Return Group |
Client Business Unit |
Client Sub ID |
Sort Name* |
Client ID* |
Client Type |
Tax Type |
Client ID-Sub ID* |
Financial Reporting Client Group* |
|
Sorting |
---|
Note: This section is hidden for the optimized report. However, by default, the report has a static sort by client. |
Client |
Report Fields
The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.
Report Fields | |
---|---|
Field | Description |
Client |
The client name and ID in Last Name, First Name (Sub-ID) format. |
Last Payment |
The client’s last payment date and amount. |
A/R Limit |
The client's AR limit set in the client profile. |
Total |
The total amount for WIP and AR. |
Current |
The amount for the current aging for WIP/AR, defined in Options and Settings. |
2nd Aging Interval |
The amount for the second aging for WIP/AR, defined in Options and Settings. |
3rd Aging Interval |
The amount for the third aging for WIP/AR, defined in Options and Settings. |
4th Aging Interval |
The amount for the fourth aging for WIP/AR, defined in Options and Settings. |
5th Aging Interval |
The amount for the fifth aging for WIP/AR, defined in Options and Settings. |
6th Aging Interval |
The amount for the sixth aging for WIP/AR, defined in Options and Settings. |
7th Aging Interval |
The amount for the seventh aging for WIP/AR, defined in Options and Settings. |
WIP/AR Aging Sample Report
Optimized WIP/AR Aging Sample Report